/*
 Navicat Premium Data Transfer

 Source Server         : jw1
 Source Server Type    : MySQL
 Source Server Version : 50733
 Source Host           : 127.0.0.1:3306
 Source Schema         : jwtest1

 Target Server Type    : MySQL
 Target Server Version : 50733
 File Encoding         : 65001

 Date: 09/02/2022 09:29:46
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for jwtest_case_list
-- ----------------------------
DROP TABLE IF EXISTS `jwtest_case_list`;
CREATE TABLE `jwtest_case_list` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `web` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `module` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `title` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `url` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `method` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `headers` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `cookies` varchar(1000) COLLATE utf8_bin DEFAULT NULL,
  `request_body` varchar(1000) COLLATE utf8_bin DEFAULT NULL,
  `request_type` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `relation` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `expected_code` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT ' 作为\n    断言标准 ',
  `isdel` int(11) DEFAULT '1' COMMENT '0 为删除， 1 为正常',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Records of jwtest_case_list
-- ----------------------------
BEGIN;
INSERT INTO `jwtest_case_list` VALUES (1, 'okr-api', '登录模块', '密码错误', '/api/User', 'post', '{\"Content-Type\": \"application/json\"}', '{}', '{\"username\":\"admin\",\"password\":\"xxxxx\"}', 'json', '', '密码错误', 1);
INSERT INTO `jwtest_case_list` VALUES (2, 'okr-api', '登录模块', '没有密码参数', '/api/User', 'post', '{\"Content-Type\": \"application/json\"}', '{}', '{\"username\":\"admin\"}', 'json', '', '密码错误', 1);
INSERT INTO `jwtest_case_list` VALUES (3, 'okr-api', '登录模块', '用户名错误', '/api/User', 'post', '{\"Content-Type\": \"application/json\"}', '{}', '{\"username\":\"admin22\",\"password\":\"123\"}', 'json', '', '没有找到用户', 1);
INSERT INTO `jwtest_case_list` VALUES (4, 'okr-api', '登录模块', '用户名错误', '/api/User', 'post', '{\"Content-Type\": \"application/json\"}', '{}', '{\"password\":\"123\"}', 'json', '', '没有找到用户', 1);
INSERT INTO `jwtest_case_list` VALUES (5, 'okr-api', '登录模块', '用户名密码正确', '/api/User', 'post', '{\"Content-Type\": \"application/json\"}', '{}', '{\"username\":\"admin\",\"password\":\"123\"}', 'json', 'jwtoken=Authorization', 'True', 1);
INSERT INTO `jwtest_case_list` VALUES (6, 'okr-api', '用户信息模块', '查询(无授权码)', '/api/User?IsEnabled=true&page=1', 'get', '{\"Content-Type\": \"application/x-www-form-urlencoded\"}', '{}', '{}', 'data', '', '500', 1);
INSERT INTO `jwtest_case_list` VALUES (7, 'okr-api', '用户信息模块', '查询(有授权码)', '/api/User?IsEnabled=true&page=1', 'get', '{\"Content-Type\": \"application/x-www-form-urlencoded\",\"Authorization\":\"${jwtoken}\"}', '{}', '{}', 'data', '', '200', 1);
COMMIT;

-- ----------------------------
-- Table structure for jwtest_config
-- ----------------------------
DROP TABLE IF EXISTS `jwtest_config`;
CREATE TABLE `jwtest_config` (
  `id` int(11) NOT NULL,
  `web` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `key1` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `value` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Records of jwtest_config
-- ----------------------------
BEGIN;
INSERT INTO `jwtest_config` VALUES (1, 'atstudy_okr', 'url_api', 'http://127.0.0.1:6088');
COMMIT;

-- ----------------------------
-- Table structure for jwtest_result_record
-- ----------------------------
DROP TABLE IF EXISTS `jwtest_result_record`;
CREATE TABLE `jwtest_result_record` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `case_id` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `times` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `response` varchar(1000) COLLATE utf8_bin DEFAULT NULL COMMENT '实际结果',
  `result` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=153 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Records of jwtest_result_record
-- ----------------------------
BEGIN;
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
